#C کلید ورود به بازار کار

دوره پروژه‌محور #C و ASP.NET Core

C#
C#
مشخصات فیلم
  • 7527
  • 2807
  • 0
  • 0.0
  • 0

آموزش SQL Server Continuous Database Delivery بوسیله Flyway

با مشاهده این دوره آموزشی استفاده از Flyway را به منظور Continuous Database Delivery دیتابیس هایSQL Server  را خواهید آموخت. بوسیلهContinuous Database Delivery  می توان بسیاری از مشکلات مرتبط با تغییرات پایگاه داده و ارائه آن به مشتریان را رفع نمود.

این مجموعه آموزش ویدیویی محصول موسسه آموزشی PluralSight  است که به صورت کاملا رایگان به همراه فایل های تمرینی و اسلایدهای مدرس و به مدت زمان 6 ساعت و 25 دقیقه در اختیار علاقه مندان قرار می گیرد.

clip_image002

clip_image004

clip_image006

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش SQL Server آشنا می شویم.

Continuous Database Delivery
Welcome to the Course

Shared Development Databases

What Changed?

Manual Database Updates

Continuous Database Delivery

What Makes This Approach Worthwhile?

What You'll Learn in This Course


Tracking Changes

Introduction

Tracking and Applying Changes

Introducing Flyway

How We're Going to Build a New Payroll DB

Demo: Setting up SQL Server Locally for a Dedicated Dev DB

Demo: Downloading Flyway

Demo: Creating a payroll DB and Connecting Flyway to the DB

Demo: Adding a First Employee Table

Demo: How to Name Change Scripts

Demo: Adding a Second Titles Table with Data

Demo: Dropping and Recreating Dev DBs at the Push of a Button

Demo: Adding Table Relationships with Employee Titles

Demo: Adding an Employee Positions View

Recap


Development Workflow

Introduction

A Robust Development Workflow

Demo: Push Button Backup

Demo: Push Button Restore

Demo: Trying Out the Development Workflow

Careful with Database Name in Generated Scripts

Demo: What Happens When a Migration Fails?

Demo: How to Correct a Mistake in a Migration

Recap


Reverse Engineering Dev DB Changes

A Robust Reverse Engineering Workflow

Demo: Creating a Comparison DB from a Dev DB Backup

Demo: Trying the Reverse Engineering Workflow

Demo: Creating a Comparison DB From Migrations Alone

Recap


Pulling Changes

Introduction

Safely Applying Changes

Demo: We've Been Trolled

Demo: Finding Out About Changes on App Startup

Demo: Migrating Databases on App Startup

Demo: Catching Changed Migrations on App Startup

Two Cooks in the Kitchen

Recap


Delivery Workflow

Introduction

An Overview of CI and Database Changes

Demo: A Script to Test Database Changes

Demo: Setting up TeamCity to Test Database Changes on Checkin

The Sky's the Limit of What You Can Test in CI

Simulating a Production Database Release

Demo: Using TeamCity to Simulate a Production Release

Recap


Transition Existing Databases

Introduction

A Transition Strategy for Existing Databases

What We're Going to Do in This Module

Demo: Setting up a Dev and Prod Database

Demo: Step 1 Baselining Prod

Alignment Strategies

Demo: Step 2 Aligning Dev to Prod

Demo: Step 3 Writing Change Scripts

Demo: Step 4 Marking Dev as v2

Demo: Step 5 Marking Prod as v1

Demo: Step 6 Migrating Prod to v2

Detecting Drift in Production

Recap


Rethinking How We Develop

Introduction

Delivering Frequently

Incentives to Rally Support

Code Based Migrations

Creative Change

Down? What Does Rollback Look Like?

What About Branching?

What Next After This Course?

دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش اول
دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش دوم
دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش سوم
1394/11/20 7527 2807
رمز عبور : tahlildadeh.com یا www.tahlildadeh.com
نظرات شما

نظرات خود را ثبت کنید...